//
//  BookSQL.h
//  readNovels
//
//  Created by 吳瀾洲 on 2020/4/27.
//  Copyright © 2020 wulanzhou. All rights reserved.
//

#ifndef BookSQL_h
#define BookSQL_h

//书籍sql操作

//新增
#define insert_book_sql     @"insert into book(name,author,price,publisher,isbn,status,ctime,mtime) values(?,?,?,?,?,?,?,?)"

//修改
#define update_book_status      @"update book set status = ?,mtime = ? where id = ?"

//查询操作
#define query_all_book    @"select * from book"
#define query_id_book     @"select * from book where id = ?"
#define query_status_book @"select * from book where status = ?"
#define query_name_book @"select * from book where `name` = ?"

#endif /* BookSQL_h */
